package com.ship.dispatch.mapper.fob;/*
 *@title SpFobZzcbdlMapper
 *@description
 *@author yl
 *@create 2023/12/16 0016
 */

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ship.dispatch.bean.fob.SpFobZzcbdl;
import com.ship.dispatch.bean.orderPay.ConShippingAgency;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

public interface SpFobZzcbdlMapper extends BaseMapper<SpFobZzcbdl> {
    @Select("SELECT * FROM con_shipping_agency WHERE id = #{cronId}")
    Map<String, Object> getCroInfo(@Param("cronId") String cronId);

    @Select("SELECT id,company_name FROM con_shipping_agency WHERE id = #{cronId}")
    ConShippingAgency getCroInfoByid(String cronId);
}
